900 |
How do I get sorted the column as string, numeric, date, date and time. Also how can it be applied to drop down filter panel
local var_Column,var_Column1,var_Column2,var_Column3,var_Column4 as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Date")} var_Column:SortType := SortDate var_Column:DisplayFilterButton := true var_Column:DisplayFilterPattern := false var_Column:DisplayFilterDate := true var_Column:FilterList := exShowFocusItem | exShowCheckBox | exSortItemsDesc var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("DateTime")} var_Column1:SortType := SortDateTime var_Column1:DisplayFilterButton := true var_Column1:DisplayFilterPattern := false var_Column1:FilterList := exShowFocusItem | exShowCheckBox | exSortItemsDesc var_Column2 := IColumn{oDCOCX_Exontrol1:Columns:Add("Time")} var_Column2:SortType := SortTime var_Column2:DisplayFilterButton := true var_Column2:DisplayFilterPattern := false var_Column2:FilterList := exShowFocusItem | exShowCheckBox | exSortItemsDesc var_Column2:FormatColumn := "time(value)" var_Column3 := IColumn{oDCOCX_Exontrol1:Columns:Add("Numeric")} var_Column3:SortType := SortNumeric var_Column3:DisplayFilterButton := true var_Column3:FilterList := exShowFocusItem | exShowCheckBox | exSortItemsDesc var_Column4 := IColumn{oDCOCX_Exontrol1:Columns:Add("String")} var_Column4:DisplayFilterButton := true var_Column4:FilterList := exShowFocusItem | exShowCheckBox | exSortItemsDesc var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem(SToD("20100127")) var_Items:[CellCaption,h,1] := SToD("20100127 10:00:00") var_Items:[CellCaption,h,2] := var_Items:[CellCaption,h,1] var_Items:[CellCaption,h,3] := 1 var_Items:[CellCaption,h,4] := var_Items:[CellCaption,h,3] h := var_Items:AddItem(SToD("20110127")) var_Items:[CellCaption,h,1] := SToD("20110127 09:00:00") var_Items:[CellCaption,h,2] := var_Items:[CellCaption,h,1] var_Items:[CellCaption,h,3] := 11 var_Items:[CellCaption,h,4] := var_Items:[CellCaption,h,3] h := var_Items:AddItem(SToD("20101102")) var_Items:[CellCaption,h,1] := SToD("20101102 09:00:00") var_Items:[CellCaption,h,2] := var_Items:[CellCaption,h,1] var_Items:[CellCaption,h,3] := 2 var_Items:[CellCaption,h,4] := var_Items:[CellCaption,h,3] oDCOCX_Exontrol1:Columns:[Item,"DateTime"]:DisplayFilterDate := false oDCOCX_Exontrol1:EndUpdate() |
899 |
I am using Layout property to sort multiple columns at once. The problem is that all items get expanded. How do I prevent that
local var_Column,var_Column1 as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("P1")} var_Column:[Def,exCellHasCheckBox] := true var_Column:PartialCheck := true var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("P2")} var_Column1:[Def,exCellHasCheckBox] := true var_Column1:PartialCheck := true var_Column1:FormatColumn := "1 index ``" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child A") var_Items:InsertItem(h,nil,"Child B") var_Items:InsertItem(h,nil,"Child A") var_Items:InsertItem(h,nil,"Child B") var_Items:AddItem("Root") var_Items:AddItem("Root") oDCOCX_Exontrol1:SingleSort := false oDCOCX_Exontrol1:Layout := "multiplesort=" + CHR(34) + "C0:1 C1:2" + CHR(34) + ";collapse=" + CHR(34) + "" + CHR(34) + "" oDCOCX_Exontrol1:EndUpdate() |
898 |
How can I get ride / hide the image being dragged by OLE Drag and Drop
METHOD OCX_Exontrol1OLEStartDrag(Data,AllowedEffects) CLASS MainDialog // OLEStartDrag event - Occurs when the OLEDrag method is called. // Data.SetData("data to drag") AllowedEffects := 1 RETURN NIL local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:OLEDropMode := exOLEDropManual oDCOCX_Exontrol1:[Background,exDragDropAfter] := RGB(255,255,255) oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:Columns:Add("Default") var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") var_Items:[ExpandItem,h] := true |
897 |
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 3)
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems local h,hChild as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:DrawGridLines := exRowLines oDCOCX_Exontrol1:AutoDrag := exAutoDragPositionAny oDCOCX_Exontrol1:HasLines := exSolidLine oDCOCX_Exontrol1:Indent := 16 oDCOCX_Exontrol1:MarkSearchColumn := false var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("")} var_Column:[Def,exCellCaptionFormat] := 1 var_Column:FormatColumn := "((1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 + `` : (=:0 mid (1 + 1 + =:1) ) + `)` ) + ` ` + value" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") var_Items:[ExpandItem,0] := true h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:[CellState,hChild,0] := 1 var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") oDCOCX_Exontrol1:EndUpdate() |
896 |
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 2)
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems local h,hChild as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:GridLineColor := RGB(190,190,190) oDCOCX_Exontrol1:DrawGridLines := exRowLines oDCOCX_Exontrol1:AutoDrag := exAutoDragPositionAny oDCOCX_Exontrol1:HasLines := exSolidLine oDCOCX_Exontrol1:Indent := 16 var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Default") var_Column := IColumn{var_Columns:Add("")} var_Column:[Def,exCellCaptionFormat] := 1 var_Column:[Def,exCellPaddingRight] := 4 var_Column:AllowSizing := false var_Column:Width := 36 var_Column:Position := 0 var_Column:FormatColumn := "(1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 : (`............` left 2 * (=:0 count `.`)) + (=:0 mid (1 + 1 + =:1) ) " var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") var_Items:[ExpandItem,0] := true h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:[CellState,hChild,0] := 1 var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") oDCOCX_Exontrol1:EndUpdate() |
895 |
I'm trying to use automatic numbering of the outline. How can I have A, B, C for root items, 1, 2, 3 for the sub-items, and a, b, c for sub-sub-items (sample 1)
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems local h,hChild as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:DrawGridLines := exRowLines oDCOCX_Exontrol1:AutoDrag := exAutoDragPositionAny oDCOCX_Exontrol1:HasLines := exSolidLine oDCOCX_Exontrol1:Indent := 16 var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Default") var_Column := IColumn{var_Columns:Add("")} var_Column:[Def,exCellCaptionFormat] := 1 var_Column:[Def,exCellPaddingRight] := 4 var_Column:Alignment := RightAlignment var_Column:AllowSizing := false var_Column:Width := 24 var_Column:Position := 0 var_Column:FormatColumn := "(1:=(0 :=(1 rpos '.|A-Z||a-z|')) rfind `.`) < 0 ? `<b>` + =:0 : `<i>` + (=:0 mid (1 + 1 + =:1) ) " var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") var_Items:[ExpandItem,0] := true h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child") hChild := var_Items:InsertItem(h,nil,"Child") var_Items:[CellState,hChild,0] := 1 var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(hChild,nil,"Child") var_Items:InsertItem(h,nil,"Child") oDCOCX_Exontrol1:EndUpdate() |
894 |
Is it possible to have a different alignment for parts of the cell's caption
local var_Column as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:TreeColumnIndex := -1 oDCOCX_Exontrol1:DrawGridLines := exRowLines oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Default")} var_Column:[Def,exCellHasCheckBox] := true var_Items := oDCOCX_Exontrol1:Items var_Items:[CellHAlignment,var_Items:AddItem("all-left"),0] := LeftAlignment var_Items:[CellHAlignment,var_Items:AddItem("all-center"),0] := CenterAlignment var_Items:[CellHAlignment,var_Items:AddItem("all-right"),0] := RightAlignment h := var_Items:AddItem("left<c>center<r>right") var_Items:[CellCaptionFormat,h,0] := exHTML oDCOCX_Exontrol1:EndUpdate() |
893 |
I have a column with Def(exCellSingleLine) property on False, word-wrapping, and I am wondering if possible to update the column's content while user is resizing it
local var_Column,var_Column1 as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("MultipleLine")} var_Column:Width := 32 var_Column:[Def,exCellSingleLine] := false var_Column:[Def,exColumnResizeContiguously] := true var_Column1 := IColumn{var_Columns:Add("SingleLine")} var_Column1:[Def,exCellSingleLine] := false var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("This is a bit of long text that should break the line"),1] := "This is a bit of long text that should break the line" oDCOCX_Exontrol1:EndUpdate() |
892 |
How do I sort the index column as numeric
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:[CellData,Item,1] := var_Items:[ItemToIndex,Item] RETURN NIL local var_Column,var_Column1 as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:DrawGridLines := exAllLines oDCOCX_Exontrol1:ColumnAutoResize := true oDCOCX_Exontrol1:ShowFocusRect := false var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Next")} var_Column:[Def,exCellPaddingLeft] := 4 var_Column:[Def,exHeaderPaddingLeft] := 4 var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("Index")} var_Column1:AllowSizing := false var_Column1:Width := 48 var_Column1:FormatColumn := "(((0 := (1 index ``)) mod 3) case ( default: ``; 0 : `<r><fgcolor=B0B0B0>`; 1: ``; 2 : `<c><fgcolor=808080>` )) + str(=:0)" var_Column1:[Def,exCellCaptionFormat] := 1 var_Column1:SortType := SortUserData var_Column1:Position := 0 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Item 1") var_Items:AddItem("Item 2") var_Items:AddItem("Item 3") var_Items:AddItem("Item 4") var_Items:AddItem("Item 5") var_Items:AddItem("Item 6") var_Items:AddItem("Item 7") var_Items:AddItem("Item 8") var_Items:AddItem("Item 9") var_Items:AddItem("Item 10") oDCOCX_Exontrol1:EndUpdate() |
891 |
How can I put icons/images into buttons
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := true oDCOCX_Exontrol1:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("C+B")} var_Column:AllowSizing := false var_Column:Width := 48 var_Column:FormatColumn := "` <img>` + ( 1 + (1 index ``) mod 3 ) + `</img> `" var_Column:[Def,exCellCaptionFormat] := 1 var_Column:[Def,exCellHasCheckBox] := true var_Column:[Def,exCellHasButton] := true var_Column:[Def,exCellButtonAutoWidth] := true oDCOCX_Exontrol1:Columns:Add("") oDCOCX_Exontrol1:DrawGridLines := exVLines oDCOCX_Exontrol1:DefaultItemHeight := 20 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") oDCOCX_Exontrol1:EndUpdate() |
890 |
Is it possible to have a CheckBox and Button TOGETHER on all cells in a column
METHOD OCX_Exontrol1CellButtonClick(Item,ColIndex) CLASS MainDialog // CellButtonClick event - Fired after the user clicks on the cell of button type. OutputDebugString(String2Psz( "CellButtonClick" )) OutputDebugString(String2Psz( AsString(Item) )) RETURN NIL METHOD OCX_Exontrol1CellStateChanged(Item,ColIndex) CLASS MainDialog // CellStateChanged event - Fired after cell's state has been changed. OutputDebugString(String2Psz( "CellStateChanged" )) OutputDebugString(String2Psz( AsString(Item) )) RETURN NIL local var_Column,var_Column1 as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := true var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("")} var_Column:AllowSizing := false var_Column:Width := 32 var_Column:FormatColumn := "1 index ``" var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("Def")} var_Column1:AllowSizing := false var_Column1:Width := 48 var_Column1:FormatColumn := "` `" var_Column1:[Def,exCellHasCheckBox] := true var_Column1:[Def,exCellHasButton] := true var_Column1:[Def,exCellButtonAutoWidth] := true oDCOCX_Exontrol1:Columns:Add("") var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") var_Items:AddItem("") oDCOCX_Exontrol1:EndUpdate() |
889 |
Does filtering work with umlauts / accents characters
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Names")} var_Column:DisplayFilterButton := true var_Column:FilterType := exPattern var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Mantel") var_Items:AddItem("Mechanik") var_Items:AddItem("Motor") var_Items:AddItem("Murks") var_Items:AddItem("Märchen") var_Items:AddItem("Möhren") var_Items:AddItem("Mühle") var_Items:AddItem("Sérigraphie") oDCOCX_Exontrol1:Columns:[Item,0]:Filter := "*ä*" oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
888 |
Can I set the search box / filterbarprompt to invisible, so I can use my own input and *string* via VBA
local var_Columns as IColumns local var_Items as IItems local h0 as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := true oDCOCX_Exontrol1:ContinueColumnScroll := false oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SearchColumnIndex := 1 oDCOCX_Exontrol1:FilterBarHeight := 0 oDCOCX_Exontrol1:FilterBarPromptVisible := true oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Columns := oDCOCX_Exontrol1:Columns IColumn{var_Columns:Add("Name")}:Width := 96 IColumn{var_Columns:Add("Title")}:Width := 96 var_Columns:Add("City") var_Items := oDCOCX_Exontrol1:Items h0 := var_Items:AddItem("Nancy Davolio") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "Seattle" h0 := var_Items:AddItem("Andrew Fuller") var_Items:[CellCaption,h0,1] := "Vice President, Sales" var_Items:[CellCaption,h0,2] := "Tacoma" var_Items:[SelectItem,h0] := true h0 := var_Items:AddItem("Janet Leverling") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "Kirkland" h0 := var_Items:AddItem("Margaret Peacock") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "Redmond" h0 := var_Items:AddItem("Steven Buchanan") var_Items:[CellCaption,h0,1] := "Sales Manager" var_Items:[CellCaption,h0,2] := "London" h0 := var_Items:AddItem("Michael Suyama") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "London" h0 := var_Items:AddItem("Robert King") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "London" h0 := var_Items:AddItem("Laura Callahan") var_Items:[CellCaption,h0,1] := "Inside Sales Coordinator" var_Items:[CellCaption,h0,2] := "Seattle" h0 := var_Items:AddItem("Anne Dodsworth") var_Items:[CellCaption,h0,1] := "Sales Representative" var_Items:[CellCaption,h0,2] := "London" oDCOCX_Exontrol1:FilterBarPromptPattern := "London" oDCOCX_Exontrol1:EndUpdate() |
887 |
How to load a hierarchy using the control's DataSource property (Parent-ID-Relation)
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:SetParent(Item,var_Items:[FindItem,var_Items:[CellCaption,Item,"ReportsTo"],"EmployeeID",nil]) RETURN NIL local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("SELECT * FROM Employees ORDER BY ReportsTo","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\SAMPLE.MDB",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Items:[ExpandItem,0] := true oDCOCX_Exontrol1:EndUpdate() |
886 |
The week number is not correct. What can I do
|
885 |
How can I display my logo on print/print-preview
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:PageOrientation := 2 var_Print:[HTMLPicture,"logo"] := "c:\exontrol\images\zipdisk.gif" var_Print:ExtraCaption("logo","<img>logo</img>",1,1) var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
884 |
How can I align captions of items with checkbox, with items with no checkbox
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Columns:Add("Default") var_Items := oDCOCX_Exontrol1:Items var_Items:[CellImages,var_Items:AddItem(0),0] := "1" var_Items:[CellHasCheckBox,var_Items:AddItem(1),0] := true var_Items:[CellImages,var_Items:AddItem(2),0] := "1" oDCOCX_Exontrol1:EndUpdate() |
883 |
How do I show the chart's labels in 24-hour clock format
local var_Chart as IChart local var_Level,var_Level1,var_Level2 as ILevel var_Chart := oDCOCX_Exontrol1:Chart var_Chart:[PaneWidth,false] := 0 var_Chart:FirstVisibleDate := SToD("20010101") var_Chart:LevelCount := 3 var_Level := var_Chart:[Level,0] var_Level:Label := "<%mmm%> <%d%>, <%yyyy%>" var_Level:Alignment := exHOutside | CenterAlignment var_Level:Unit := exDay var_Level1 := var_Chart:[Level,1] var_Level1:Label := "<b><%h%>:00</b>" var_Level1:Alignment := CenterAlignment var_Level1:Unit := exHour var_Level1:DrawTickLines := true var_Level1:DrawGridLines := true var_Level2 := var_Chart:[Level,2] var_Level2:Label := "<%nn%>" var_Level2:Unit := exMinute var_Level2:Count := 15 var_Chart:ScrollTo(SToD("20010101 08:30:00"),0) |
882 |
How do I show the chart's labels in 12-hour clock format
local var_Chart as IChart local var_Level,var_Level1,var_Level2 as ILevel var_Chart := oDCOCX_Exontrol1:Chart var_Chart:[PaneWidth,false] := 0 var_Chart:FirstVisibleDate := SToD("20010101") var_Chart:LevelCount := 3 var_Level := var_Chart:[Level,0] var_Level:Label := "<%mmm%> <%d%>, <%yyyy%>" var_Level:Alignment := exHOutside | CenterAlignment var_Level:Unit := exDay var_Level1 := var_Chart:[Level,1] var_Level1:Label := "<b><%h%>:00</b> <%AM/PM%>" var_Level1:Alignment := CenterAlignment var_Level1:Unit := exHour var_Level1:DrawTickLines := true var_Level1:DrawGridLines := true var_Level2 := var_Chart:[Level,2] var_Level2:Label := "<%nn%>" var_Level2:Unit := exMinute var_Level2:Count := 15 var_Chart:ScrollTo(SToD("20010101 08:30:00"),0) |
881 |
The control does not ensure the item to fit the control's client area once the user clicks the cell's button or check box. What can be done
METHOD OCX_Exontrol1MouseDown(Button,Shift,X,Y) CLASS MainDialog // MouseDown event - Occurs when the user presses a mouse button. // Items.EnsureVisibleItem(ItemFromPoint(-1,-1,c,hit)) RETURN NIL local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:TreeColumnIndex := -1 oDCOCX_Exontrol1:SelForeColor := oDCOCX_Exontrol1:ForeColor var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Buttons")} var_Column:Alignment := CenterAlignment var_Column:[Def,exCellHasButton] := true var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Button A") var_Items:AddItem("Button B") var_Items:AddItem("Button C") oDCOCX_Exontrol1:EndUpdate() |
880 |
Do you have any Fit-To-Page options when printing the control (W x T, Fit-To )
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "FitToPage =1 x 2" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
879 |
Do you have any Fit-To-Page options when printing the control ( x T, Fit-To Tall )
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "FitToPage = x 2" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
878 |
Do you have any Fit-To-Page options when printing the control ( W x, Fit-To Wide )
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "FitToPage = 2 x" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
877 |
Do you have any Fit-To-Page options when printing the control ( percent view, Adjust-To )
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "FitToPage = 50%" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
876 |
Does the title of the cell's tooltip supports HTML format
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("")} var_Column:Caption := "" var_Column:HTMLCaption := "Column" var_Items := oDCOCX_Exontrol1:Items var_Items:[CellToolTip,var_Items:AddItem("tooltip w/h different title"),0] := "<c><b><fgcolor=FF0000>Title</fgcolor></b><br>This is bit of text that's shown when the user hovers the cell. This shows the title centered with a different color." oDCOCX_Exontrol1:EndUpdate() |
875 |
How do I specify a different title for the cell's tooltip
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("")} var_Column:Caption := "This is the title" var_Column:HTMLCaption := "Column" var_Items := oDCOCX_Exontrol1:Items var_Items:[CellToolTip,var_Items:AddItem("tooltip w/h different title"),0] := "This is bit of text that's shown when the user hovers the cell." oDCOCX_Exontrol1:EndUpdate() |
874 |
The cell's tooltip displays the column's caption in its title. How can I get ride of that
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("C1") var_Columns:Add("C2") var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("tooltip w/h caption") var_Items:[CellToolTip,h,0] := "This is bit of text that's shown when the user hovers the cell. This shows the column's caption in the title." var_Items:[CellCaption,h,1] := "tooltip no caption" var_Items:[CellToolTip,h,1] := "This is bit of text that's shown when the user hovers the cell. This shows no column's caption in the title." var_Column := oDCOCX_Exontrol1:Columns:[Item,"C2"] var_Column:HTMLCaption := var_Column:Caption var_Column:Caption := "" oDCOCX_Exontrol1:EndUpdate() |
873 |
How can I programmatically show the column's filter
METHOD OCX_Exontrol1RClick() CLASS MainDialog // RClick event - Fired when right mouse button is clicked local i as USUAL i := oDCOCX_Exontrol1:[ItemFromPoint,-1,-1,c,hit] oDCOCX_Exontrol1:Columns:[Item,c]:ShowFilter("-1,-1,128,128") RETURN NIL local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ShowFocusRect := false var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Items ")} var_Column:DisplayFilterPattern := false var_Column:FilterList := exShowExclude | exShowFocusItem | exShowCheckBox var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Item 1") var_Items:AddItem("Item 2") var_Items:AddItem("Item 3") oDCOCX_Exontrol1:EndUpdate() |
872 |
I want to be able to click on one of the headers, and sort by other column. How can I do that (method 2)
METHOD OCX_Exontrol1ColumnClick(Column) CLASS MainDialog // ColumnClick event - Fired after the user clicks on column's header. // Column.SortOrder = 1 oDCOCX_Exontrol1:SortOnClick := exDefaultSort oDCOCX_Exontrol1:Columns:[Item,"Sort"]:SortOrder := SortAscending oDCOCX_Exontrol1:SortOnClick := exUserSort RETURN NIL local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SortOnClick := exUserSort oDCOCX_Exontrol1:Columns:Add("Items") IColumn{oDCOCX_Exontrol1:Columns:Add("Sort")}:Visible := false var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("Item 1 (3)"),1] := 3 var_Items:[CellCaption,var_Items:AddItem("Item 2 (1)"),1] := 1 var_Items:[CellCaption,var_Items:AddItem("Item 3 (2)"),1] := 2 oDCOCX_Exontrol1:EndUpdate() |
871 |
I want to be able to click on one of the headers, and sort by other column. How can I do that (method 1)
METHOD OCX_Exontrol1ColumnClick(Column) CLASS MainDialog // ColumnClick event - Fired after the user clicks on column's header. // Column.SortOrder = 1 oDCOCX_Exontrol1:Items:SortChildren(0,"Sort",true) RETURN NIL local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SortOnClick := exUserSort oDCOCX_Exontrol1:Columns:Add("Items") IColumn{oDCOCX_Exontrol1:Columns:Add("Sort")}:Visible := false var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("Item 1 (3)"),1] := 3 var_Items:[CellCaption,var_Items:AddItem("Item 2 (1)"),1] := 1 var_Items:[CellCaption,var_Items:AddItem("Item 3 (2)"),1] := 2 oDCOCX_Exontrol1:EndUpdate() |
870 |
How can I sort by two-columns, one by date and one by time
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:SingleSort := false var_Columns := oDCOCX_Exontrol1:Columns IColumn{var_Columns:Add("Index")}:FormatColumn := "1 index ``" IColumn{var_Columns:Add("Date")}:SortType := SortDate var_Column := IColumn{var_Columns:Add("Time")} var_Column:SortType := SortTime var_Column:FormatColumn := "time(value)" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20010101") var_Items:[CellCaption,h,2] := SToD("20010101 10:00:00") h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20001231") var_Items:[CellCaption,h,2] := SToD("20010101 10:00:00") h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20010101") var_Items:[CellCaption,h,2] := SToD("20010101 06:00:00") h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20001231") var_Items:[CellCaption,h,2] := SToD("20010101 08:00:00") h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20010101") var_Items:[CellCaption,h,2] := SToD("20010101 08:00:00") h := var_Items:AddItem(0) var_Items:[CellCaption,h,1] := SToD("20001231") var_Items:[CellCaption,h,2] := SToD("20010101 06:00:00") oDCOCX_Exontrol1:Layout := "multiplesort=" + CHR(34) + "C1:1 C2:1" + CHR(34) + "" oDCOCX_Exontrol1:EndUpdate() |
869 |
How can I connect to a DBF file
|
868 |
How can I change the bar's color based on values on the columns
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Chart as IChart local var_ConditionalFormat,var_ConditionalFormat1,var_ConditionalFormat2 as IConditionalFormat local var_ConditionalFormats as IConditionalFormats local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("19940803") var_Chart:[PaneWidth,false] := 256 var_Chart:LevelCount := 2 var_Chart:UnitScale := exDay var_Chart:FirstWeekDay := exMonday var_Chart:OverviewVisible := exOverviewShowAll oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} var_ConditionalFormats := oDCOCX_Exontrol1:ConditionalFormats var_ConditionalFormat := var_ConditionalFormats:Add("1",nil) var_ConditionalFormat:ApplyTo := 0x1 | var_ConditionalFormat:Bold := true var_ConditionalFormat:BackColor := RGB(250,250,250) var_ConditionalFormat1 := var_ConditionalFormats:Add("%1 = 5",nil) var_ConditionalFormat1:ApplyToBars := "Task" var_ConditionalFormat1:BarColor := RGB(255,0,0) var_ConditionalFormat1:ForeColor := RGB(255,0,0) var_ConditionalFormat1:BarOverviewColor := RGB(255,0,0) var_ConditionalFormat2 := var_ConditionalFormats:Add("%1 = 3",nil) var_ConditionalFormat2:ApplyToBars := "Task" var_ConditionalFormat2:BarColor := RGB(0,255,0) var_ConditionalFormat2:ForeColor := RGB(0,255,0) var_ConditionalFormat2:BarOverviewColor := RGB(0,255,0) oDCOCX_Exontrol1:EndUpdate() |
867 |
Does your control supports scrolling by touching the screen
|
866 |
How can I export the control's content to a PDF document (method 1)
local var_Chart as IChart local var_Print as IExPrint local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:Columns:Add("Tasks") var_Chart := oDCOCX_Exontrol1:Chart var_Chart:[PaneWidth,false] := 196 var_Chart:LevelCount := 2 var_Chart:ShowEmptyBars := 1 var_Chart:FirstVisibleDate := SToD("20090101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20090102"),SToD("20090107"),nil,nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20090104"),SToD("20090109"),nil,nil) // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:CopyTo("c:/temp/xtest.pdf") OutputDebugString(String2Psz( "Look for C:\Temp\xtest.pdf file." )) oDCOCX_Exontrol1:EndUpdate() |
865 |
How can I export the control's content to a PDF document (method 2)
local var_Chart as IChart local var_Items as IItems local var_CopyTo as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:Columns:Add("Tasks") var_Chart := oDCOCX_Exontrol1:Chart var_Chart:[PaneWidth,false] := 196 var_Chart:LevelCount := 2 var_Chart:ShowEmptyBars := 1 var_Chart:FirstVisibleDate := SToD("20090101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20090102"),SToD("20090107"),nil,nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20090104"),SToD("20090109"),nil,nil) var_CopyTo := oDCOCX_Exontrol1:[CopyTo,"c:/temp/xtest.pdf"] OutputDebugString(String2Psz( "Look for C:\Temp\xtest.pdf file." )) oDCOCX_Exontrol1:EndUpdate() |
864 |
Is there a syntax for conditional formatting of items, based on CellState/CellStateChange
METHOD OCX_Exontrol1CellStateChanged(Item,ColIndex) CLASS MainDialog // CellStateChanged event - Fired after cell's state has been changed. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,Item,2] := var_Items:[CellState,Item,0] RETURN NIL local var_Column as IColumn local var_ConditionalFormat as IConditionalFormat local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ShowFocusRect := false oDCOCX_Exontrol1:SelBackMode := exTransparent var_ConditionalFormat := oDCOCX_Exontrol1:ConditionalFormats:Add("%2 != 0",nil) var_ConditionalFormat:Bold := true var_ConditionalFormat:ForeColor := RGB(255,0,0) var_ConditionalFormat:ApplyTo := exFormatToItems var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("")} var_Column:[Def,exCellHasCheckBox] := true var_Column:Width := 16 var_Column:AllowSizing := false oDCOCX_Exontrol1:Columns:Add("Information") IColumn{oDCOCX_Exontrol1:Columns:Add("Hidden")}:Visible := false var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem(""),1] := "This is a bit of text associated" h := var_Items:AddItem("") var_Items:[CellCaption,h,1] := "This is a bit of text associated" var_Items:[CellState,h,0] := 1 var_Items:[CellCaption,var_Items:AddItem(""),1] := "This is a bit of text associated" oDCOCX_Exontrol1:EndUpdate() |
863 |
How can I use no scroll bars for touch-screens
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Chart as IChart local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("19940803") var_Chart:[PaneWidth,false] := 256 var_Chart:LevelCount := 2 var_Chart:UnitScale := exDay var_Chart:FirstWeekDay := exMonday var_Chart:OverviewVisible := exOverviewShowAll oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:AutoDrag := exAutoDragScroll oDCOCX_Exontrol1:ScrollWidth := 4 oDCOCX_Exontrol1:ScrollHeight := 4 oDCOCX_Exontrol1:[Background,exHSLeft] := RGB(192,192,192) oDCOCX_Exontrol1:[Background,exHSRight] := RGB(192,192,192) oDCOCX_Exontrol1:[Background,exHSBack] := RGB(224,224,224) oDCOCX_Exontrol1:[Background,exHSThumb] := RGB(128,128,128) oDCOCX_Exontrol1:[Background,exVSBack] := RGB(224,224,224) oDCOCX_Exontrol1:[Background,exVSDown] := RGB(192,192,192) oDCOCX_Exontrol1:[Background,exVSThumb] := RGB(128,128,128) oDCOCX_Exontrol1:[Background,exVSUp] := RGB(192,192,192) oDCOCX_Exontrol1:ScrollButtonWidth := 0 oDCOCX_Exontrol1:ScrollButtonHeight := 0 oDCOCX_Exontrol1:EndUpdate() |
862 |
How can I print the selected items only
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local var_Items as IItems local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:SingleSel := false oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") var_Items := oDCOCX_Exontrol1:Items var_Items:[SelectItem,var_Items:[ItemByIndex,0]] := true var_Items:[SelectItem,var_Items:[ItemByIndex,2]] := true var_Items:[SelectItem,var_Items:[ItemByIndex,4]] := true oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "Print = Selection" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
861 |
How can I sort the columns to be displayed on the columns floating bar
|
860 |
How can I add a vertical padding
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:DrawGridLines := exAllLines var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Padding")} var_Column:[Def,exCellHasCheckBox] := true var_Column:[Def,exCellSingleLine] := false var_Column:[Def,exCellPaddingLeft] := 6 var_Column:[Def,exCellPaddingRight] := 6 var_Column:[Def,exCellPaddingTop] := 6 var_Column:[Def,exCellPaddingBottom] := 6 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("padding") var_Items:AddItem("padding") oDCOCX_Exontrol1:EndUpdate() |
859 |
How do you embed HTML options into the anchor click string
METHOD OCX_Exontrol1AnchorClick(AnchorID,Options) CLASS MainDialog // AnchorClick event - Occurs when an anchor element is clicked. OutputDebugString(String2Psz( AsString(AnchorID) )) OutputDebugString(String2Psz( AsString(Options) )) RETURN NIL local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() var_Columns := oDCOCX_Exontrol1:Columns IColumn{var_Columns:Add("Car")}:[Def,exCellCaptionFormat] := 1 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("<a mazda_1;options for 1>Mazda <b>1</b></a>") var_Items:AddItem("<a mazda_2;options for 2>Mazda <b>2</b></a>") var_Items:AddItem("<a mazda_3;options for 3a>Mazda <b>3.a</b></a>") var_Items:AddItem("<a mazda_3;options for 3b>Mazda <b>3.b</b></a>") oDCOCX_Exontrol1:EndUpdate() |
858 |
I have the rows with different background color, and when I select the item it takes the color of the SelBackColor, and therefore is no longer visible behind the color. Is there any option to make the item's color being visible (method 3)
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:VisualAppearance:Add(1,"gBFLBCJwBAEHhEJAEGg4BVEIQAAYAQGKIYBkAKBQAGaAoDDMOQwQwAAxjGKEEwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZLiEZRQCWIAzATGYBRfIUEgjBM6ExwG78egBHp/ZpkACIJJAaRjHQdJxGKKMQB9DIhCZpeKhWgkKIJBzOEyBRC4ERBGqNGrsIgLEqWZpnWhaNpWXYTLyBN64LhuK46g53O6wLxvK6hEr2dJ/YBcIAOfghf4NQ7EMRxLC8Mw3BDvYDkOAABAIgI=") oDCOCX_Exontrol1:SelBackColor := 0x1fffffe oDCOCX_Exontrol1:ShowFocusRect := false oDCOCX_Exontrol1:Columns:Add("Items") var_Items := oDCOCX_Exontrol1:Items var_Items:[ItemBackColor,var_Items:AddItem("red")] := RGB(255,0,0) var_Items:[ItemBackColor,var_Items:AddItem("blue")] := RGB(0,0,255) var_Items:[ItemBackColor,var_Items:AddItem("green")] := RGB(0,255,0) oDCOCX_Exontrol1:EndUpdate() |
857 |
I have the rows with different background color, and when I select the item it takes the color of the SelBackColor, and therefore is no longer visible behind the color. Is there any option to make the item's color being visible (method 2)
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:SelBackMode := exTransparent oDCOCX_Exontrol1:ShowFocusRect := false oDCOCX_Exontrol1:Columns:Add("Items") var_Items := oDCOCX_Exontrol1:Items var_Items:[ItemBackColor,var_Items:AddItem("red")] := RGB(255,0,0) var_Items:[ItemBackColor,var_Items:AddItem("blue")] := RGB(0,0,255) var_Items:[ItemBackColor,var_Items:AddItem("green")] := RGB(0,255,0) oDCOCX_Exontrol1:EndUpdate() |
856 |
I have the rows with different background color, and when I select the item it takes the color of the SelBackColor, and therefore is no longer visible behind the color. Is there any option to make the item's color being visible (method 1)
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:SelBackColor := oDCOCX_Exontrol1:BackColor oDCOCX_Exontrol1:SelForeColor := oDCOCX_Exontrol1:ForeColor oDCOCX_Exontrol1:ShowFocusRect := true oDCOCX_Exontrol1:Columns:Add("Items") var_Items := oDCOCX_Exontrol1:Items var_Items:[ItemBackColor,var_Items:AddItem("red")] := RGB(255,0,0) var_Items:[ItemBackColor,var_Items:AddItem("blue")] := RGB(0,0,255) var_Items:[ItemBackColor,var_Items:AddItem("green")] := RGB(0,255,0) oDCOCX_Exontrol1:EndUpdate() |
855 |
Do you have any Fit-To-Page options when printing the control
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Print as IExPrint local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("19940804") oDCOCX_Exontrol1:EndUpdate() // Generate Source for 'ExPrint 1.0 Control Library(ExPrint.dll)' server from Tools\Automation Server... var_Print := IExPrint{"Exontrol.Print"} var_Print:Options := "FitToPage = On" var_Print:PrintExt := oDCOCX_Exontrol1 var_Print:Preview() |
854 |
How can I add a footer row
local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:ShowLockedItems := true oDCOCX_Exontrol1:DrawGridLines := exVLines oDCOCX_Exontrol1:Columns:Add("C1") oDCOCX_Exontrol1:Columns:Add("C2") var_Items := oDCOCX_Exontrol1:Items var_Items:[LockedItemCount,BottomAlignment] := 1 h := var_Items:[LockedItem,BottomAlignment,0] var_Items:[ItemBackColor,h] := RGB(128,128,128) var_Items:[ItemForeColor,h] := RGB(255,255,255) var_Items:[CellCaption,h,0] := "footer c1" var_Items:[CellCaption,h,1] := "footer c2" var_Items:[CellCaption,var_Items:AddItem("cell"),1] := "cell" |
853 |
How can I add a header row
local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:ShowLockedItems := true oDCOCX_Exontrol1:DrawGridLines := exVLines oDCOCX_Exontrol1:Columns:Add("C1") oDCOCX_Exontrol1:Columns:Add("C2") var_Items := oDCOCX_Exontrol1:Items var_Items:[LockedItemCount,TopAlignment] := 1 h := var_Items:[LockedItem,TopAlignment,0] var_Items:[ItemBackColor,h] := RGB(128,128,128) var_Items:[ItemForeColor,h] := RGB(255,255,255) var_Items:[CellCaption,h,0] := "footer c1" var_Items:[CellCaption,h,1] := "footer c2" var_Items:[CellCaption,var_Items:AddItem("cell"),1] := "cell" |
852 |
How can I programmatically add more columns to the sort bar and other to be sorted, but not included in the sort bar
local var_Columns as IColumns oDCOCX_Exontrol1:SortBarVisible := true var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add(AsString(0)) var_Columns:Add(AsString(1)) var_Columns:Add(AsString(2)) var_Columns:Add(AsString(3)) var_Columns:Add(AsString(4)) oDCOCX_Exontrol1:Layout := "multiplesort=" + CHR(34) + "C3:1 C4:2" + CHR(34) + ";singlesort=" + CHR(34) + "C2:1" + CHR(34) + "" |
851 |
How can I fix a column, while other sizable and fill the control's client
local var_Column as IColumn oDCOCX_Exontrol1:ColumnAutoResize := true oDCOCX_Exontrol1:Columns:Add("Sizable") var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("F")} var_Column:AllowSizing := false var_Column:Width := 16 |
850 |
When I'm trying to show string with "line break" character (vbCrLF) in a textbox, it shows 2 squares. Is there any way to hide these squares
local var_Column,var_Column1,var_Column2 as IColumn local var_Columns as IColumns local var_Items as IItems var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Value") var_Column := IColumn{var_Columns:Add("CellSingleLine = False")} var_Column:ComputedField := "%0" var_Column:[Def,exCellSingleLine] := false var_Column1 := IColumn{var_Columns:Add("FormatColumn/replace CRLF")} var_Column1:ComputedField := "%0" var_Column1:FormatColumn := "value replace `\r\n` with ``" var_Column2 := IColumn{var_Columns:Add("FormatColumn/replace TAB,CRLF")} var_Column2:ComputedField := "%0" var_Column2:FormatColumn := "(value replace `\t` with ``) replace `\r\n` with ``" var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("a\ta\r\nb\tb") |
849 |
Is there any way to "unselect" radio group
METHOD OCX_Exontrol1DblClick(Shift,X,Y) CLASS MainDialog // DblClick event - Occurs when the user dblclk the left mouse button over an object. local var_Items as IItems local h as USUAL var_Items := oDCOCX_Exontrol1:Items h := var_Items:[CellChecked,1234] var_Items:[CellHasCheckBox,0,h] := true var_Items:[CellState,0,h] := 0 var_Items:[CellHasCheckBox,0,h] := false RETURN NIL METHOD OCX_Exontrol1SelectionChanged() CLASS MainDialog // SelectionChanged event - Fired after a new item has been selected. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:[CellState,var_Items:FocusItem,0] := 1 RETURN NIL local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SelBackColor := RGB(255,255,128) oDCOCX_Exontrol1:SelForeColor := RGB(0,0,0) oDCOCX_Exontrol1:Columns:Add("Default") var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Radio 1") var_Items:[CellHasRadioButton,h,0] := true var_Items:[CellRadioGroup,h,0] := 1234 h := var_Items:AddItem("Radio 2") var_Items:[CellHasRadioButton,h,0] := true var_Items:[CellRadioGroup,h,0] := 1234 var_Items:[CellState,h,0] := 1 h := var_Items:AddItem("Radio 3") var_Items:[CellHasRadioButton,h,0] := true var_Items:[CellRadioGroup,h,0] := 1234 |
848 |
The Column.Alignment property does not seem to work for cells with images in them. What can be done
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oDCOCX_Exontrol1:TreeColumnIndex := -1 oDCOCX_Exontrol1:DrawGridLines := exAllLines oDCOCX_Exontrol1:HeaderHeight := 24 oDCOCX_Exontrol1:DefaultItemHeight := 24 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Image")} var_Column:AllowSizing := false var_Column:Width := 32 var_Column:HTMLCaption := "<img>1</img>" var_Column:HeaderAlignment := CenterAlignment var_Column:Alignment := CenterAlignment var_Column:[Def,exCellCaptionFormat] := 1 oDCOCX_Exontrol1:Columns:Add("Rest") var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("<img>1</img>") var_Items:AddItem("<img>2</img>") var_Items:AddItem("<img>3</img>") oDCOCX_Exontrol1:EndUpdate() |
847 |
Does your control support subscript or superscript, in HTML captions
|
846 |
How do I arrange my columns on multiple levels
local var_Column,var_Column1,var_Column2 as IColumn local var_Columns as IColumns oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:DrawGridLines := exAllLines var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("C0")} var_Column:ExpandColumns := "1,2" var_Column:DisplayExpandButton := false var_Columns:Add("C1") var_Columns:Add("C2") var_Columns:Add("C3") var_Column1 := IColumn{var_Columns:Add("C4")} var_Column1:ExpandColumns := "5,6" var_Column1:DisplayExpandButton := false var_Columns:Add("C5") var_Column2 := IColumn{var_Columns:Add("C6")} var_Column2:ExpandColumns := "6,7" var_Column2:DisplayExpandButton := false var_Columns:Add("C7") oDCOCX_Exontrol1:EndUpdate() |
845 |
Does your control support expandable header or columns, so I can arrange it on multiple levels
local var_Column,var_Column1 as IColumn local var_Columns as IColumns oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:DrawGridLines := exAllLines oDCOCX_Exontrol1:BackColorLevelHeader := RGB(240,240,240) var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("Photo")} var_Column:AllowSizing := false var_Column:Width := 32 var_Columns:Add("Personal Info") var_Columns:Add("Title") var_Columns:Add("Name") var_Columns:Add("First") var_Columns:Add("Last") var_Columns:Add("Address") var_Columns:[Item,"Personal Info"]:ExpandColumns := "2,3" var_Column1 := var_Columns:[Item,"Name"] var_Column1:ExpandColumns := "4,5" var_Column1:Expanded := false oDCOCX_Exontrol1:EndUpdate() |
844 |
Can I change the format of date to be shown in the control
local var_Column,var_Column1,var_Column2 as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Default") var_Column := IColumn{var_Columns:Add("Format.1")} var_Column:ComputedField := "%0" var_Column:FormatColumn := "dateF(value) replace `/` with `-`" var_Column1 := IColumn{var_Columns:Add("Format.2")} var_Column1:ComputedField := "%0" var_Column1:[Def,exCellCaptionFormat] := 1 var_Column1:FormatColumn := "`<b>`+ shortdate(value) + `</b> ` + timeF(value)" var_Column2 := IColumn{var_Columns:Add("Format.3")} var_Column2:ComputedField := "%0" var_Column2:[Def,exCellCaptionFormat] := 1 var_Column2:FormatColumn := "` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `Fr`; 6 : `Sa`) ) + `</b> ` + ( dateF(value) replace `/` with `-` )" var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem(SToD("20010101 10:00:00")) var_Items:AddItem(SToD("20010102 10:00:00")) |
843 |
How can I remove all bars from the chart
local var_Items as IItems oDCOCX_Exontrol1:Columns:Add("Task") oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("20010101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 3"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 4"),"Task",SToD("20010102"),SToD("20010104"),"K2",nil) var_Items:ClearBars(0) |
842 |
How can I change the color for all bars with a specified key
local var_Items as IItems oDCOCX_Exontrol1:Columns:Add("Task") oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("20010101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 3"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 4"),"Task",SToD("20010102"),SToD("20010104"),"K2",nil) var_Items:[ItemBar,0,"K1",exBarColor] := 255 |
841 |
Is there any automatic way to change a property for all bars with a specified key
local var_Items as IItems oDCOCX_Exontrol1:Columns:Add("Task") oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("20010101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 3"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 4"),"Task",SToD("20010102"),SToD("20010104"),"K2",nil) var_Items:[ItemBar,0,"K1",exBarColor] := 255 |
840 |
How can I remove all bars with specified key
local var_Items as IItems oDCOCX_Exontrol1:Columns:Add("Task") oDCOCX_Exontrol1:Chart:FirstVisibleDate := SToD("20010101") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Task 1"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 2"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 3"),"Task",SToD("20010102"),SToD("20010104"),"K1",nil) var_Items:AddBar(var_Items:AddItem("Task 4"),"Task",SToD("20010102"),SToD("20010104"),"K2",nil) var_Items:RemoveBar(0,"K1") |
839 |
How can I find if there is any filter applied to the control
METHOD OCX_Exontrol1FilterChange() CLASS MainDialog // FilterChange event - Occurs when the filter was changed. OutputDebugString(String2Psz( "If negative, the filter is present, else not" )) OutputDebugString(String2Psz( AsString(oDCOCX_Exontrol1:Items:VisibleItemCount) )) RETURN NIL local var_Column as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:TreeColumnIndex := -1 oDCOCX_Exontrol1:FilterInclude := exMatchingItemsOnly var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilter var_Column:Filter := "C1" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("R1") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") var_Items:[ExpandItem,h] := true h := var_Items:AddItem("R2") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
838 |
How can I prevent showing the lines for the hierarchy while using the exMatchingItemsOnly option
local var_Column as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:TreeColumnIndex := -1 oDCOCX_Exontrol1:FilterInclude := exMatchingItemsOnly var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilter var_Column:Filter := "C1|C2" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("R1") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") var_Items:[ExpandItem,h] := true h := var_Items:AddItem("R2") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
837 |
Is there any method to get only the matched items and not the items with his parent
local var_Column as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:FilterInclude := exMatchingItemsOnly var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Column")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilter var_Column:Filter := "C1|C2" var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("R1") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") var_Items:[ExpandItem,h] := true h := var_Items:AddItem("R2") var_Items:InsertItem(h,nil,"C1") var_Items:InsertItem(h,nil,"C2") oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
836 |
Is there any property I can save and restore automatically the current setting, column position, size, and so on (2)
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Columns:Add("Column") var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Item 1") var_Items:AddItem("Item 2") var_Items:AddItem("Item 3") oDCOCX_Exontrol1:Layout := "Select=" + CHR(34) + "0" + CHR(34) + ";SingleSort=" + CHR(34) + "C0:2" + CHR(34) + ";Columns=1" oDCOCX_Exontrol1:EndUpdate() |
835 |
Is there any property I can save and restore automatically the current setting, column position, size, and so on (1)
local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Columns:Add("Column") var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Item 1") var_Items:AddItem("Item 2") var_Items:AddItem("Item 3") oDCOCX_Exontrol1:Layout := "gBjAAwAAuABmABpABsAB0ABlAByhoAPIAOEPAA9gYABoABQAgUEg0XN4AOcJicKkpujMbjsfkMFk0YhkQgUOjUEl8gjcGO0ok8KMULjEaGMcj08kQAO8oMkTNEtGwAGQAqc7gUlhh1ABtAEsk9GpEfhElgVcsMupNlnlonlaAFcr0shUsp8QPEtnVJqJhmcIhUMh0QiU5sYAqMngUSuEMw07k8Qv0SgVRrNEuVflF2jF5x9JyNEm0TjQijemyE0jE3t+YruauoAu4Az1qj9BzRn0UzksSnAA0xDjY6qnAw8OiUQ0dwzN0zWz2t7j8/xURAGNvWH6k8xlEhklhEI0O/6QAgI=" oDCOCX_Exontrol1:EndUpdate() |
834 |
I have noticed that the column's header is changed once the cursor hovers it. Is it possible to change that visual appearance
local var_Columns as IColumns oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn") var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") var_Columns:Add("Column 2") oDCOCX_Exontrol1:BackColorHeader := 0x1000000 oDCOCX_Exontrol1:[Background,exCursorHoverColumn] := 0x12d86ff |
833 |
Is it possible to change the visual appearance of the columns selector/floating bar(3)
local var_Columns as IColumns oDCOCX_Exontrol1:ColumnAutoResize := false var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") IColumn{var_Columns:Add("Column 2")}:Visible := false oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\normal.ebn") oDCOCX_Exontrol1:VisualAppearance:Add(3,"c:\exontrol\images\pushed.ebn") oDCOCX_Exontrol1:[Background,exColumnsFloatAppearance] := 0x2000000 oDCOCX_Exontrol1:[Background,exColumnsFloatBackColor] := 0x3000000 oDCOCX_Exontrol1:[Background,exColumnsFloatCaptionBackColor] := RGB(246,245,240) oDCOCX_Exontrol1:ColumnsFloatBarVisible := exColumnsFloatBarVisibleIncludeHiddenColumns |
832 |
Is it possible to change the visual appearance of the columns selector/floating bar(2)
local var_Columns as IColumns oDCOCX_Exontrol1:ColumnAutoResize := false var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") IColumn{var_Columns:Add("Column 2")}:Visible := false oDCOCX_Exontrol1:VisualAppearance:Add(3,"c:\exontrol\images\pushed.ebn") oDCOCX_Exontrol1:[Background,exColumnsFloatBackColor] := 0x3000000 oDCOCX_Exontrol1:ColumnsFloatBarVisible := exColumnsFloatBarVisibleIncludeHiddenColumns |
831 |
Is it possible to change the visual appearance of the columns selector/floating bar(1)
oDCOCX_Exontrol1:VisualAppearance:Add(2,"c:\exontrol\images\normal.ebn") oDCOCX_Exontrol1:[Background,exColumnsFloatAppearance] := 0x2000000 oDCOCX_Exontrol1:[Background,exColumnsFloatBackColor] := RGB(246,245,240) oDCOCX_Exontrol1:[Background,exColumnsFloatCaptionBackColor] := RGB(246,245,240) oDCOCX_Exontrol1:ColumnsFloatBarVisible := exColumnsFloatBarVisibleIncludeHiddenColumns |
830 |
I am using the ColumnsFloatBarVisible property on True, but still not able to add any column on that list
|
829 |
Is it possible to list a column to columns selector/floating bar, but still user can use it
local var_Column as IColumn local var_Columns as IColumns oDCOCX_Exontrol1:ColumnAutoResize := false var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") IColumn{var_Columns:Add("Column 2")}:Visible := false var_Column := IColumn{var_Columns:Add("Column 3")} var_Column:Visible := false var_Column:Enabled := false oDCOCX_Exontrol1:ColumnsFloatBarVisible := exColumnsFloatBarVisibleIncludeHiddenColumns |
828 |
How can I prevent a specific column not to be listed in the columns selector/floating bar
|
827 |
Is it possible to change the "Columns" caption being shown in the columns selector/floating bar
local var_Columns as IColumns oDCOCX_Exontrol1:ColumnAutoResize := false var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") IColumn{var_Columns:Add("Column 2")}:Visible := false oDCOCX_Exontrol1:[Description,exColumnsFloatBar] := "Hidden Columns" oDCOCX_Exontrol1:ColumnsFloatBarVisible := exColumnsFloatBarVisibleIncludeHiddenColumns |
826 |
How can I show the columns selector, so the user can drag and drop columns to the view
|
825 |
The column's header is changed while the cursor hovers it. Is it possible to prevent that
local var_Columns as IColumns var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Column 1") var_Columns:Add("Column 2") oDCOCX_Exontrol1:[Background,exCursorHoverColumn] := -1 |
824 |
How do I enable the scrollbar-extension, as thumb to be shown outside of the control's client area
oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:ScrollBars := exDisableBoth oDCOCX_Exontrol1:Chart:ToolTip := "" oDCOCX_Exontrol1:[ScrollPartVisible,exVScroll,exExtentThumbPart] := true oDCOCX_Exontrol1:[ScrollPartVisible,exHScroll,exExtentThumbPart] := true oDCOCX_Exontrol1:[ScrollPartVisible,exHChartScroll,exExtentThumbPart] := true oDCOCX_Exontrol1:ScrollWidth := 4 oDCOCX_Exontrol1:[Background,exVSBack] := RGB(240,240,240) oDCOCX_Exontrol1:[Background,exVSThumb] := RGB(128,128,128) oDCOCX_Exontrol1:ScrollHeight := 4 oDCOCX_Exontrol1:[Background,exHSBack] := oDCOCX_Exontrol1:[Background,exVSBack] oDCOCX_Exontrol1:[Background,exHSThumb] := oDCOCX_Exontrol1:[Background,exVSThumb] oDCOCX_Exontrol1:[Background,exScrollSizeGrip] := oDCOCX_Exontrol1:[Background,exVSBack] oDCOCX_Exontrol1:EndUpdate() |
823 |
How can I display the Year in Thai, Buddhist, Korean format
local var_Chart as IChart local var_Level as ILevel var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstWeekDay := var_Chart:LocFirstWeekDay var_Chart:MonthNames := var_Chart:LocMonthNames var_Chart:WeekDays := var_Chart:LocWeekDays var_Chart:AMPM := var_Chart:LocAMPM var_Chart:LevelCount := 2 var_Chart:[PaneWidth,false] := 0 var_Chart:UnitScale := exDay var_Level := var_Chart:[Level,0] var_Level:Label := "<%mmmm%> <%d%>, <%loc_yyyy%> <r><%ww%>" var_Level:Unit := exWeek var_Level:ToolTip := var_Level:Label var_Chart:ToolTip := "<%ddd%> <%m%>/<%d%>/<%loc_yyyy%>" oDCOCX_Exontrol1:[Description,exFilterBarDateMonths] := oDCOCX_Exontrol1:Chart:MonthNames |
822 |
How does localization work
local var_Chart as IChart var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstWeekDay := var_Chart:LocFirstWeekDay var_Chart:MonthNames := var_Chart:LocMonthNames var_Chart:WeekDays := var_Chart:LocWeekDays var_Chart:AMPM := var_Chart:LocAMPM var_Chart:LevelCount := 2 var_Chart:[PaneWidth,false] := 0 |
821 |
How can I have a case-insensitive filter (exFilterDoCaseSensitive flag is not set)
local var_Column,var_Column1 as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:MarkSearchColumn := false var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("Car")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilter var_Column:Filter := "MAZDA" var_Column1 := IColumn{var_Columns:Add("Equipment")} var_Column1:DisplayFilterButton := true var_Column1:DisplayFilterPattern := false var_Column1:CustomFilter := "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*" var_Column1:FilterType := exPattern var_Column1:Filter := "AIR BAG" var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "Air Bag" var_Items:[CellCaption,var_Items:AddItem("Toyota"),1] := "Air Bag,Air condition" var_Items:[CellCaption,var_Items:AddItem("Ford"),1] := "Air condition" var_Items:[CellCaption,var_Items:AddItem("Nissan"),1] := "Air Bag,ABS,ESP" var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "Air Bag, ABS,ESP" var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "ABS,ESP" oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
820 |
How can I have a case-sensitive filter
local var_Column,var_Column1 as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:MarkSearchColumn := false var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("Car")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilterDoCaseSensitive | exFilter var_Column:Filter := "Mazda" var_Column1 := IColumn{var_Columns:Add("Equipment")} var_Column1:DisplayFilterButton := true var_Column1:DisplayFilterPattern := false var_Column1:CustomFilter := "Air Bag||*Air Bag*|||Air condition||*Air condition*|||ABS||*ABS*|||ESP||*ESP*" var_Column1:FilterType := exFilterDoCaseSensitive | exPattern var_Column1:Filter := "Air Bag" var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "Air Bag" var_Items:[CellCaption,var_Items:AddItem("Toyota"),1] := "Air Bag,Air condition" var_Items:[CellCaption,var_Items:AddItem("Ford"),1] := "Air condition" var_Items:[CellCaption,var_Items:AddItem("Nissan"),1] := "Air Bag,ABS,ESP" var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "Air Bag, ABS,ESP" var_Items:[CellCaption,var_Items:AddItem("Mazda"),1] := "ABS,ESP" oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
819 |
I am using the FormatColumn/FormatCell to format my columns. Is it possible to ignore the SelForeColor, so the foreground color for selected items does not override my settings
METHOD OCX_Exontrol1SelectionChanged() CLASS MainDialog // SelectionChanged event - Fired after a new item has been selected. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:ClearItemBackColor(0) var_Items:[ItemBackColor,var_Items:[SelectedItem,0]] := RGB(128,255,255) RETURN NIL local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SelForeColor := oDCOCX_Exontrol1:ForeColor oDCOCX_Exontrol1:SelBackColor := oDCOCX_Exontrol1:BackColor oDCOCX_Exontrol1:ShowFocusRect := false var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("Format")} var_Column:FormatColumn := "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=0000FF>+'+(value format '2|.|3|,' ): '0.00') )" var_Column:[Def,exCellCaptionFormat] := 1 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem(10) var_Items:AddItem(-8) oDCOCX_Exontrol1:EndUpdate() |
818 |
How do I hide the selection
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:MarkSearchColumn := false oDCOCX_Exontrol1:SelForeColor := oDCOCX_Exontrol1:ForeColor oDCOCX_Exontrol1:SelBackColor := oDCOCX_Exontrol1:BackColor oDCOCX_Exontrol1:ShowFocusRect := false var_Columns := oDCOCX_Exontrol1:Columns var_Column := IColumn{var_Columns:Add("Format")} var_Column:FormatColumn := "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=0000FF>+'+(value format '2|.|3|,' ): '0.00') )" var_Column:[Def,exCellCaptionFormat] := 1 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem(10) var_Items:AddItem(-8) oDCOCX_Exontrol1:EndUpdate() |
817 |
How do I access the cells, or how do I get the values in the columns
|
816 |
How can I change the check-boxes appearance
local var_Appearance as IAppearance local var_Column as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Default")} var_Column:[Def,exCellHasCheckBox] := true var_Column:PartialCheck := true var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") var_Items:[ExpandItem,h] := true var_Appearance := oDCOCX_Exontrol1:VisualAppearance var_Appearance:Add(1,"XP:Button 3 12") var_Appearance:Add(2,"XP:Button 3 11") var_Appearance:Add(3,"XP:Button 3 10") oDCOCX_Exontrol1:[CheckImage,Unchecked] := 16777216 oDCOCX_Exontrol1:[CheckImage,Checked] := 33554432 oDCOCX_Exontrol1:[CheckImage,PartialChecked] := 50331648 |
815 |
How can I load my table from an Access 2007, using ADO
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Chart as IChart local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("19940803") var_Chart:[PaneWidth,false] := 256 var_Chart:LevelCount := 2 var_Chart:UnitScale := exDay var_Chart:FirstWeekDay := exMonday var_Chart:OverviewVisible := exOverviewShowAll oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\sample.accdb",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:EndUpdate() |
814 |
Is it possible display numbers in the same format no matter of regional settings in the control panel
local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() IColumn{oDCOCX_Exontrol1:Columns:Add("Def")}:[Def,exCellCaptionFormat] := 1 var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem(666666.27) var_Items:[FormatCell,h,0] := "(value format '') + ' <fgcolor=808080>(default positive)'" h := var_Items:AddItem(666666.27) var_Items:[FormatCell,h,0] := "(value format '2|.|3|,|1|1')" h := var_Items:AddItem(-666666.27) var_Items:[FormatCell,h,0] := "(value format '') + ' <fgcolor=808080>(default negative)'" h := var_Items:AddItem(-666666.27) var_Items:[FormatCell,h,0] := "(value format '2|.|3|,|1|1')" oDCOCX_Exontrol1:EndUpdate() |
813 |
The right pane needs to show ONLY the hours 6am to 9pm (every hour) for one day only and the user should not to be able to scroll left or right nor see any other hours. How can I do that
local var_Chart as IChart oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Columns:Add("Tasks") var_Chart := oDCOCX_Exontrol1:Chart var_Chart:LevelCount := 2 var_Chart:[ScrollRange,exStartDate] := SToD("20010101") var_Chart:[ScrollRange,exEndDate] := SToD("20010101") var_Chart:UnitScale := exHour var_Chart:NonworkingHours := 12582975 var_Chart:ShowNonworkingUnits := false var_Chart:[Level,0]:Alignment := exHOutside | CenterAlignment var_Chart:UnitWidth := 18 var_Chart:[PaneWidth,true] := 294 var_Chart:ScrollBar := false oDCOCX_Exontrol1:OnResizeControl := exDisableSplitter oDCOCX_Exontrol1:EndUpdate() |
812 |
Can I use ebn files to display the selected dates
local var_Appearance as IAppearance local var_Chart as IChart local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() var_Appearance := oDCOCX_Exontrol1:VisualAppearance var_Appearance:Add(2,"c:\exontrol\images\normal.ebn") var_Appearance:Add(1,"CP:2 0 -4 0 4") var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("20080101") var_Chart:MarkTodayColor := var_Chart:BackColor var_Chart:LevelCount := 2 var_Chart:MarkSelectDateColor := 0x1000000 var_Chart:SelectLevel := 1 var_Chart:[SelectDate,SToD("20080103")] := true var_Chart:[SelectDate,SToD("20080104")] := true oDCOCX_Exontrol1:Columns:Add("Default") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Item 1"),"Task",SToD("20080102"),SToD("20080106"),nil,nil) var_Items:AddBar(var_Items:AddItem("Item 2"),"Task",SToD("20080103"),SToD("20080107"),nil,nil) var_Items:AddBar(var_Items:AddItem("Item 3"),"Task",SToD("20080104"),SToD("20080108"),nil,nil) var_Items:AddBar(var_Items:AddItem("Item 4"),"Task",SToD("20080105"),SToD("20080109"),nil,nil) oDCOCX_Exontrol1:EndUpdate() |
811 |
Can I use ebn files to display the selected dates
local var_Chart as IChart local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:VisualAppearance:Add(1,"c:\exontrol\images\normal.ebn") var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("20080101") var_Chart:MarkTodayColor := var_Chart:BackColor var_Chart:LevelCount := 2 var_Chart:MarkSelectDateColor := 0x1000000 var_Chart:SelectLevel := 1 var_Chart:[SelectDate,SToD("20080103")] := true oDCOCX_Exontrol1:Columns:Add("Default") var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(var_Items:AddItem("Item 1"),"Task",SToD("20080102"),SToD("20080106"),nil,nil) var_Items:AddBar(var_Items:AddItem("Item 2"),"Task",SToD("20080103"),SToD("20080107"),nil,nil) var_Items:AddBar(var_Items:AddItem("Item 3"),"Task",SToD("20080104"),SToD("20080108"),nil,nil) oDCOCX_Exontrol1:EndUpdate() |
810 |
How can I change the color for selected dates to be solid
|
809 |
How can I add or change the padding (spaces) for captions in the control's header
local var_Column as IColumn oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 IColumn{oDCOCX_Exontrol1:Columns:Add("Padding-Left")}:[Def,exHeaderPaddingLeft] := 18 var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Padding-Right")} var_Column:[Def,exHeaderPaddingRight] := 18 var_Column:HeaderAlignment := RightAlignment oDCOCX_Exontrol1:EndUpdate() |
808 |
Do you have any plans to add cell spacing and cell padding to the cells
local var_Column as IColumn local var_Items as IItems oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:DrawGridLines := exAllLines var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Padding-Left")} var_Column:[Def,exCellHasCheckBox] := true var_Column:[Def,exCellPaddingLeft] := 18 IColumn{oDCOCX_Exontrol1:Columns:Add("No-Padding")}:[Def,exCellHasCheckBox] := true IColumn{oDCOCX_Exontrol1:Columns:Add("Empty")}:Position := 0 var_Items := oDCOCX_Exontrol1:Items var_Items:[CellCaption,var_Items:AddItem("Item A.1"),1] := "Item A.2" var_Items:[CellCaption,var_Items:AddItem("Item B.1"),1] := "Item B.2" var_Items:[CellCaption,var_Items:AddItem("Item C.1"),1] := "Item C.2" oDCOCX_Exontrol1:EndUpdate() |
807 |
Is it possible to display information about the firing events
METHOD OCX_Exontrol1Event(EventID) CLASS MainDialog // Event event - Notifies the application once the control fires an event. OutputDebugString(String2Psz( AsString(oDCOCX_Exontrol1:[EventParam,-2]) )) RETURN NIL |
806 |
Is it possible to scroll the control's content by clicking and moving the mouse up or down
|
805 |
How do I load bars from my ADO table/database
METHOD OCX_Exontrol1AddItem(Item) CLASS MainDialog // AddItem event - Occurs after a new Item has been inserted to Items collection. local var_Items as IItems var_Items := oDCOCX_Exontrol1:Items var_Items:AddBar(Item,"Task",var_Items:[CellCaption,Item,2],var_Items:[CellCaption,Item,4],nil,nil) RETURN NIL local var_Chart as IChart local rs as _Recordset oDCOCX_Exontrol1:BeginUpdate() var_Chart := oDCOCX_Exontrol1:Chart var_Chart:FirstVisibleDate := SToD("19940803") var_Chart:[PaneWidth,false] := 256 var_Chart:LevelCount := 2 var_Chart:UnitScale := exDay var_Chart:FirstWeekDay := exMonday var_Chart:OverviewVisible := exOverviewShowAll oDCOCX_Exontrol1:ColumnAutoResize := false oDCOCX_Exontrol1:ContinueColumnScroll := false // Generate Source for 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' server from Tools\Automation Server... rs := _Recordset{"ADOR.Recordset"} rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExGantt\Sample\Access\SAMPLE.MDB",3,3,0) oDCOCX_Exontrol1:DataSource := _Recordset{rs} oDCOCX_Exontrol1:EndUpdate() |
804 |
Is it possible to auto-numbering the children items but still keeps the position after filtering
local var_Column,var_Column1,var_Column2,var_Column3,var_Column4,var_Column5,var_Column6 as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Items")} var_Column:DisplayFilterButton := true var_Column:FilterType := exFilter var_Column:Filter := "Child 2" var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.1")} var_Column1:FormatColumn := "1 ropos ''" var_Column1:Position := 0 var_Column1:Width := 32 var_Column1:AllowSizing := false var_Column2 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.2")} var_Column2:FormatColumn := "1 ropos ':'" var_Column2:Position := 1 var_Column2:Width := 32 var_Column2:AllowSizing := false var_Column3 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.3")} var_Column3:FormatColumn := "1 ropos ':|A-Z'" var_Column3:Position := 2 var_Column3:Width := 32 var_Column3:AllowSizing := false var_Column4 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.4")} var_Column4:FormatColumn := "1 ropos '|A-Z|'" var_Column4:Position := 3 var_Column4:Width := 32 var_Column4:AllowSizing := false var_Column5 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.5")} var_Column5:FormatColumn := "'<font Tahoma;7>' + 1 ropos '-<b>||A-Z'" var_Column5:[Def,exCellCaptionFormat] := 1 var_Column5:Position := 4 var_Column5:Width := 32 var_Column5:AllowSizing := false var_Column6 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.6")} var_Column6:FormatColumn := "'<b>'+ 1 ropos '</b>:<fgcolor=FF0000>|A-Z|'" var_Column6:[Def,exCellCaptionFormat] := 1 var_Column6:Position := 5 var_Column6:Width := 48 var_Column6:AllowSizing := false var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root 1") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") var_Items:[ExpandItem,h] := true h := var_Items:AddItem("Root 2") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") oDCOCX_Exontrol1:ApplyFilter() oDCOCX_Exontrol1:EndUpdate() |
803 |
Is it possible to auto-numbering the children items too
local var_Column,var_Column1,var_Column2,var_Column3,var_Column4,var_Column5 as IColumn local var_Items as IItems local h as USUAL oDCOCX_Exontrol1:BeginUpdate() oDCOCX_Exontrol1:Chart:[PaneWidth,true] := 0 oDCOCX_Exontrol1:LinesAtRoot := exLinesAtRoot oDCOCX_Exontrol1:Columns:Add("Items") var_Column := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.1")} var_Column:FormatColumn := "1 rpos ''" var_Column:Position := 0 var_Column:Width := 32 var_Column:AllowSizing := false var_Column1 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.2")} var_Column1:FormatColumn := "1 rpos ':'" var_Column1:Position := 1 var_Column1:Width := 32 var_Column1:AllowSizing := false var_Column2 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.3")} var_Column2:FormatColumn := "1 rpos ':|A-Z'" var_Column2:Position := 2 var_Column2:Width := 32 var_Column2:AllowSizing := false var_Column3 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.4")} var_Column3:FormatColumn := "1 rpos '|A-Z|'" var_Column3:Position := 3 var_Column3:Width := 32 var_Column3:AllowSizing := false var_Column4 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.5")} var_Column4:FormatColumn := "'<font Tahoma;7>' + 1 rpos '-<b>||A-Z'" var_Column4:[Def,exCellCaptionFormat] := 1 var_Column4:Position := 4 var_Column4:Width := 32 var_Column4:AllowSizing := false var_Column5 := IColumn{oDCOCX_Exontrol1:Columns:Add("Pos.6")} var_Column5:FormatColumn := "'<b>'+ 1 rpos '</b>:<fgcolor=FF0000>|A-Z|'" var_Column5:[Def,exCellCaptionFormat] := 1 var_Column5:Position := 5 var_Column5:Width := 48 var_Column5:AllowSizing := false var_Items := oDCOCX_Exontrol1:Items h := var_Items:AddItem("Root 1") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") var_Items:[ExpandItem,h] := true h := var_Items:AddItem("Root 2") var_Items:InsertItem(h,nil,"Child 1") var_Items:InsertItem(h,nil,"Child 2") oDCOCX_Exontrol1:EndUpdate() |
802 |
Is there any way to add auto-numbering
local var_Column as IColumn local var_Columns as IColumns local var_Items as IItems var_Columns := oDCOCX_Exontrol1:Columns var_Columns:Add("Items") var_Column := IColumn{var_Columns:Add("Pos")} var_Column:FormatColumn := "1 pos ''" var_Column:Position := 0 var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem("Item 1") var_Items:AddItem("Item 2") var_Items:AddItem("Item 3") |
801 |
How can I format my column to display the percent values “5,00%”
local var_Items as IItems IColumn{oDCOCX_Exontrol1:Columns:Add("Percent")}:FormatColumn := "((dbl(value) * 100) format '2|,|3.')+'%'" var_Items := oDCOCX_Exontrol1:Items var_Items:AddItem(0.5) var_Items:AddItem(0.4) var_Items:AddItem(0.75) |